PROMPT *-*-*-*-*-*-  stc_cls_trg_tb table creation STARTS... *-*-*-*-*-*-

DROP TABLE stc_cls_trg_tb
/

CREATE TABLE stc_cls_trg_tb
( stc_id      NUMBER
, stc_items   VARCHAR2(15)
, src_loc     VARCHAR2(5)
, trg_loc     VARCHAR2(5)
, stc_qty     NUMBER
, stc_typ     CHAR
, stc_desc    VARCHAR2(30)
, status      VARCHAR2(5)
, loaded_by   VARCHAR2(10)
, loaded_dttm TIMESTAMP 
)
/

PROMPT *-*-*-*-*-*-  stc_cls_trg_tb table creation ENDS... *-*-*-*-*-*-

PROMPT *-*-*-*-*-*-  stc_cls_hist_tb table creation STARTS... *-*-*-*-*-*-

DROP TABLE stc_cls_hist_tb
/

CREATE TABLE stc_cls_hist_tb
( stc_id      NUMBER
, stc_items   VARCHAR2(15)
, src_loc     VARCHAR2(5)
, trg_loc     VARCHAR2(5)
, stc_qty     NUMBER
, stc_typ     CHAR
, stc_desc    VARCHAR2(30)
, loaded_by   VARCHAR2(10)
, loaded_dttm TIMESTAMP 
)
/

PROMPT *-*-*-*-*-*-  stc_cls_hist_tb table creation ENDS... *-*-*-*-*-*-